home *** CD-ROM | disk | FTP | other *** search
/ New Perspectives on Computer Concepts / New Perspectives on Computer Concepts.iso / np2010c / page714.pag < prev    next >
Portable Network Graphic  |  2008-10-02  |  88KB  |  817x1045  |  8-bit (256 colors)
Labels: chat room | hakham | monitor | sky
OCR: 646 SECTION D CHAPTER 11 What does a simple SQL query look like? An SQL query sequence of words, much like sentence. For example, an SQL query that searches for a song called "Ruby Tuesday in Vintage Music Shop's data- base might look like this: SEL LECT TrackTitle FROM Tracks WHERE TrackTitle 'Ruby Tuesday' The SQL query language provides collection of special command words called SQL keywords such as SELECT, FROM INSERT and WHERE which issue instructions to the database Although the SQL examples in this section of the chapter use uppercase letters for keywords most implemen- tations of SQL accept either uppercase or lowercase keywords Most SQL queries can be divided into three simple elements that specify an action, the name of a database table and set of parameters Let's look ai each th ...